Tabela Session

Definicja tabeli Session

Name

Session

Code

Session

Comment

 


Lista kolumn tabeli Session

Name

Code

SessionID

SessionID

PersonID

PersonID

PIDID

PIDID

StartDT

StartDT


Kolumna SessionID tabeli Session

Definicja kolumny SessionID tabeli Session

Name

SessionID

Code

SessionID

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli Session

Definicja kolumny PersonID tabeli Session

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PIDID tabeli Session

Definicja kolumny PIDID tabeli Session

Name

PIDID

Code

PIDID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli Session

Definicja kolumny StartDT tabeli Session

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Lista kluczy tabeli Session

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Session

Definicja klucza Identifier_1 tabeli Session

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment